This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
I would suggest that you didn't talk with the right customers!
I'm sure every notes shop would tell you to improve the nsf - I hate dealing with a corrupt database, but when you actually look under the hood, perhaps these databases are being used in a more relational manner so that having a relational database as the back end makes more sense!
One of the most severe limitations in getting to documents is having a view with the 'correct' first sorted column. I have databases with more views that any other design element, and most of these views are lookups. Sometimes the lookup column is simple, other times it is a complex concatenation of drill-down key values. The query view is a simple concept that allows designers to develop views at run-time not at design-time.
Secondly, when one is trying to select a set of documents based on certain filter values, we are forced to use a full text index. How is it possible to return a filtered set of data in an orderly view (like select * from table where x=y ORDER BY z) unless there are pre-built views for every value of z?
Finally, what happens when you want to combine information from different forms (simple join in sql)? I'm told you can do this with xpages, however, I can't figure out how to use the view control to make the join. Maybe you can make the join for one record, but what if you want to launch a spreadsheet with all the documents from the above filter? What I generally do now is store the fields from the second form on the first and then write AGENTS to update the first form when values on the second change. Pretty unproductive...
I'd say the relational back end should be made a requirement, rather than trying to force domino designers into a convoluted mechanism for getting to the right data. I'm wondering right now how easy it would be to get help to craft the right sql statement, than it would be to find an xpages expert. Based on the amount of time either has been around, the answer is a no-brainer.
Feedback response number WEBB7NRPF4 created by ~Dana Chulumarflar on 01/29/2009
I would suggest that you didn't talk with the right customers!
Return to top
. . . . I would suggest that you didn't tal... (~Dana Chulumarf... 29.Jan.09) 
